UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wzmJfHbYhx5XPKpNd5sd4eiztE1f7viVTt27/zNGlEU='
WHERE
key_id = 'c99d7f66c9d11901308daad406f6aa7dc110b5e0a0679a9ac8a9e550a74d2743'
AND (
token = 'wzmJfHbYhx5XPKpNd5sd4eiztE1f7viVTt27/zNGlEU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)