UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VmIhSizMdiEhZyzK1gI6y/wRmTx1DwsDlT/n6RKVcv4='
WHERE
key_id = 'e7a4fa25f6fba465ef03bc29cdcef1ba1f6e0997e2ce745c592abc4c54b80f5a'
AND (
token = 'VmIhSizMdiEhZyzK1gI6y/wRmTx1DwsDlT/n6RKVcv4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)