UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7w2o4AlA0jHWsxKVbwvk3tpI7FEu1bN/CVgLu+DszM8='
WHERE
key_id = '47618abfd13be1cfb94d22e7c4bab196ef1bf2384bec25dd3c6ff034a26228dd'
AND (
token = '7w2o4AlA0jHWsxKVbwvk3tpI7FEu1bN/CVgLu+DszM8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)