UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'icBng0iGazsYw45DyyDID/tCizcCR2uWI+IaQwJhaQw='
WHERE
key_id = 'f003ca220ca2a9c0619193bd1f28e7ba94dfe1fc4d6afeb3b4ee8634484fc65d'
AND (
token = 'icBng0iGazsYw45DyyDID/tCizcCR2uWI+IaQwJhaQw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)