UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RBUeW337eDmpHF9RfW+QioKQVywH3ylH9x89R8LMjoA='
WHERE
key_id = 'e58e13cf50ceadd483b970bbe1d1c5580e048e97a1abe938bfb63cd52b50cbe6'
AND (
token = 'RBUeW337eDmpHF9RfW+QioKQVywH3ylH9x89R8LMjoA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)