UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4Go0JmaYf2usjVDRogVbQuTUSgHqKqsguCIFgJA4H70='
WHERE
key_id = 'cfba63864066a3f358967c8bf08cfa5f3bbdaae11e48e8e8837a20f5c653085f'
AND (
token = '4Go0JmaYf2usjVDRogVbQuTUSgHqKqsguCIFgJA4H70='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)