UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6TWRxbfdO13jrpD2lfW7hU4RuRPpXBqlNYeWdY0U2yc='
WHERE
key_id = 'b4bbec12981b384af0221d3ce45fd971143c5b84b031d82ecbaeaa0abf380f75'
AND (
token = '6TWRxbfdO13jrpD2lfW7hU4RuRPpXBqlNYeWdY0U2yc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)