UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1m0dG9iEHwOHdIEQ48dXKDjVu9F4jYzOzTgZNDAYfVw='
WHERE
key_id = 'c9475e63b52562c23bb157da0b7c90a18073df249434fbfe62a377c81c0aff3b'
AND (
token = '1m0dG9iEHwOHdIEQ48dXKDjVu9F4jYzOzTgZNDAYfVw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)