UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5/m2Io28iVes5ZFiU/mocwFGAj39quCD65wz74N88ro='
WHERE
key_id = '689b5b21c407136795b81b8b4086445daedf5cd311b206fdae30fb790b83de3e'
AND (
token = '5/m2Io28iVes5ZFiU/mocwFGAj39quCD65wz74N88ro='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)