UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mZSgs1TAEcDCSas7DUEdT8/BmRf2GJ9gfaNK4AASEeI='
WHERE
key_id = 'e2562f52ecd061345ad829f6ea3eb5de7f2142a9f4f63472555f12e6c6829c29'
AND (
token = 'mZSgs1TAEcDCSas7DUEdT8/BmRf2GJ9gfaNK4AASEeI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)