UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hx7gkfR47wroiVbP8jtD8KGzaiLqeUIUexjczJ7o7Mw='
WHERE
key_id = 'ed7d08f6a7175771d812f7da86201bdc94e1cf6ce2b609391548172d4957416a'
AND (
token = 'hx7gkfR47wroiVbP8jtD8KGzaiLqeUIUexjczJ7o7Mw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)