UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'e998C7QmkwwbiinZuyJFGcwVMdK6M6JIS6Q1vQ0BvhU='
WHERE
key_id = '564fb1df7ff5bc24c2516457e80f17bfe979489f0bc7728e27c8345b63321163'
AND (
token = 'e998C7QmkwwbiinZuyJFGcwVMdK6M6JIS6Q1vQ0BvhU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)