UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C9D1UjlBLRQU6nUw2Gq6I4n+uoy+jRw4tJnGF0J0EXQ='
WHERE
key_id = 'febb13d76b2dbe6bbb1768ea31d447ba6cda1fc118fccb4c1ca3dd2f0573d102'
AND (
token = 'C9D1UjlBLRQU6nUw2Gq6I4n+uoy+jRw4tJnGF0J0EXQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)