UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dWhln50+ziAsz80grt0s9SxL/Z6i2Gb4+gROrPT0wt4='
WHERE
key_id = '147e58eb226b2e227117c527b7606e09be4fbe4790e5b6a2a7ab7fee5cea3ac8'
AND (
token = 'dWhln50+ziAsz80grt0s9SxL/Z6i2Gb4+gROrPT0wt4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)