UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HRl11S5hcn6A5YmOd9jtnIvmTn1YprFV+TNrPsJZlMA='
WHERE
key_id = '040dbec6155d50c876d2e5be16fc4e30f096cf6925070bf79655c5fb669910ab'
AND (
token = 'HRl11S5hcn6A5YmOd9jtnIvmTn1YprFV+TNrPsJZlMA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)