UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pE096K5O8QqfO7FYNl/OY3ZhQON7YJvLxzsJIsx0vhs='
WHERE
key_id = 'ce0c4152b9514308b466eb61667842e62147882a26be69af5478b0c1bb05557d'
AND (
token = 'pE096K5O8QqfO7FYNl/OY3ZhQON7YJvLxzsJIsx0vhs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)