UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x/nlexVv10KG4wRa5sUvK2CpYTHD4nEv5TkOB3CZI68='
WHERE
key_id = '1497b1ba64d9c552fca2f6565d5ede33510049f7c4e3ee96d2372cf17fbd1f02'
AND (
token = 'x/nlexVv10KG4wRa5sUvK2CpYTHD4nEv5TkOB3CZI68='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)