UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RoSFlHaA2hO0MRGYeB1JuFGUwbNIUoImEjoJ5TSH434='
WHERE
key_id = '42670a50f434490c16c2ed86df321a792a68fedce5dddb2795b1ef96e5a56873'
AND (
token = 'RoSFlHaA2hO0MRGYeB1JuFGUwbNIUoImEjoJ5TSH434='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)