UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x6mlQmgZL/sRRW3Zaoen65kDnPfvyPgobvAoHpbHylw='
WHERE
key_id = 'a9f92e64a1d9fa3b6a8dec05f2f52ded5c11ac826b0d18a0d3a2a0caa30137fb'
AND (
token = 'x6mlQmgZL/sRRW3Zaoen65kDnPfvyPgobvAoHpbHylw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)