UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZVfUmO+Nkl1CaySfoH03hqXxo5pMoPfVUgooC1udtZY='
WHERE
key_id = 'c7acfde944b06c38d4a2c25ec74d23460aa945f4a996179974e7def8507fd0ac'
AND (
token = 'ZVfUmO+Nkl1CaySfoH03hqXxo5pMoPfVUgooC1udtZY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)