UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6Idi5ODZgon1Pu9T62HTgMONpHsH5FOFy4Ktp7T1RCc='
WHERE
key_id = '1e7322df8f820c8e9bf9f66ac1ae6062f0f56b8d64372529104956da51331cd7'
AND (
token = '6Idi5ODZgon1Pu9T62HTgMONpHsH5FOFy4Ktp7T1RCc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)