UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hUJbw9J8+1AOTDNWLZeAKgv9MbGX+GyA2Uni64rnrzc='
WHERE
key_id = 'c3bcfe8ebce1450d0e8083c82133622d6989b43bd412313cb896267c104dce23'
AND (
token = 'hUJbw9J8+1AOTDNWLZeAKgv9MbGX+GyA2Uni64rnrzc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)