UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'h147JfeM//5rXpgKZs2u8VdfKDz89aQKj1rNzZIi8Ww='
WHERE
key_id = 'c0194651154e53a3d270bd1ac20b43fb1bef9ce22e9dd51f76583b9adb6b0c85'
AND (
token = 'h147JfeM//5rXpgKZs2u8VdfKDz89aQKj1rNzZIi8Ww='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)