UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd2gMqrfxPlT04iHZkmKsk1QKK5shKNnYt1127tkVcEE='
WHERE
key_id = '66d1e5c0fa30f31158d21d2a56694b9330c6dbf387a35d9216b9c7c997f51a10'
AND (
token = 'd2gMqrfxPlT04iHZkmKsk1QKK5shKNnYt1127tkVcEE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)