UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8nZzXB7a2klR0K4y6NEZ8ChitOyqdx7GjAqCCaV0vDA='
WHERE
key_id = '3e197fa7dc7ff543a8a872ca2fa3f82b7b630f63094f648595dc67f36cdbfbac'
AND (
token = '8nZzXB7a2klR0K4y6NEZ8ChitOyqdx7GjAqCCaV0vDA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)