UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BOl2oD0wFHFzhiPsLW8lrmzOfDL2x4SVFJ/julwugiI='
WHERE
key_id = 'd20b980d181cca5ea18ca485d78aa2ba13b7d5e885a2a3f02ab70bf594c372cc'
AND (
token = 'BOl2oD0wFHFzhiPsLW8lrmzOfDL2x4SVFJ/julwugiI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)