UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q3zYXuGH03xLfFYJVr3Y9FvTkhw1R5juPPWmvNZHxCY='
WHERE
key_id = '378ec5223a353589285b78d723bb39dce330ade8f4ecd8758cd03140de3f80ed'
AND (
token = 'q3zYXuGH03xLfFYJVr3Y9FvTkhw1R5juPPWmvNZHxCY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)