UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'g4wZOhW35yarMMgVjUh5AyGAQi7E2dhJ/eePnBKIecg='
WHERE
key_id = 'fa1010d65f78473b70536b05b376360cf90c49ca20a2d06b1d42cdcd16edae34'
AND (
token = 'g4wZOhW35yarMMgVjUh5AyGAQi7E2dhJ/eePnBKIecg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)