UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/0OusI+ondswc49YLScTH936NILpcE7A8eN7ghIce9s='
WHERE
key_id = '97f6784a05c72bd96b7e6faa60be8b831967f4cd66c4b21aa5922dcc8a020326'
AND (
token = '/0OusI+ondswc49YLScTH936NILpcE7A8eN7ghIce9s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)