UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0+XPWvS9DESYB5TXqzrVYBr4QZb1W4gBdcmAxt2I+wc='
WHERE
key_id = 'db4272f00805261d38a0b7feb6f57e8698c7f54590ceff66e0df64642101eebe'
AND (
token = '0+XPWvS9DESYB5TXqzrVYBr4QZb1W4gBdcmAxt2I+wc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)