UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'T8x+KIXNY4DwbiBJQ+EB4SaL7so/t4NHsy20lrTJ0rA='
WHERE
key_id = '2a333e68cdc4d23abd320a6b1206604f17cf42a3bfb771212acd2e5921d796a8'
AND (
token = 'T8x+KIXNY4DwbiBJQ+EB4SaL7so/t4NHsy20lrTJ0rA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)