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