UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZpqB4+E8lidyhrJ5CEs56xZAtW3CIKBH/Ot5E66StzA='
WHERE
key_id = 'b266840784a2f4796dcab2d02f8e447253e08830f7df85da81cef41a16a94548'
AND (
token = 'ZpqB4+E8lidyhrJ5CEs56xZAtW3CIKBH/Ot5E66StzA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)