UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xgCoAHiTcazoqnnjfrBHw9amSBKNpigNIHmgX5g7OWU='
WHERE
key_id = '410f2c9ec16803af37173958b50cedb7f8c84bb0976b9b7211be880b996feb29'
AND (
token = 'xgCoAHiTcazoqnnjfrBHw9amSBKNpigNIHmgX5g7OWU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)