UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8JPZgr/fzzJTphWjPnCiSY8QJlP52Wi5CGGMeg21feM='
WHERE
key_id = '4b9bdb071b02a5a7eda68d4e6ad8121660abccd9c1ec74802a998e222de9a39e'
AND (
token = '8JPZgr/fzzJTphWjPnCiSY8QJlP52Wi5CGGMeg21feM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)