UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Em+o3TfDX1eWciUCArTeN4zhOvB+6/GJRe5seV3qYzE='
WHERE
key_id = '5af147a5c7e91224b97e5b1c89e8b229b4f1d588f65ccd5a4b2c9e8d413eb561'
AND (
token = 'Em+o3TfDX1eWciUCArTeN4zhOvB+6/GJRe5seV3qYzE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)