UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LYoOYkLx+fWroa4oF89+HcKtSUbW83y8/4Xw0yJyGTo='
WHERE
key_id = 'bb49cc7611d41d23a11454a09820a367e29892d35aeb3928014c9191e85b29ce'
AND (
token = 'LYoOYkLx+fWroa4oF89+HcKtSUbW83y8/4Xw0yJyGTo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)