UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Avr/fvG7tNPxJYU83l/hdIlkKrpcz8TLdAUnhV23iQE='
WHERE
key_id = '1c18c75f6e89b57846c9bedcc76411e743ff699495e7d56f8a9f48e9ffcbe0cc'
AND (
token = 'Avr/fvG7tNPxJYU83l/hdIlkKrpcz8TLdAUnhV23iQE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)