UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cl6chmYF4ufyVxJhO+eisyLVdXJxnYNGjGcGiSETPn8='
WHERE
key_id = '0b86d946fe14ef143b63b71c5123b1e3294b1b272777521dbc060694d78e24c6'
AND (
token = 'cl6chmYF4ufyVxJhO+eisyLVdXJxnYNGjGcGiSETPn8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)