UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hRMsJ5TynqHGl2xWyVcglvHY8FZuc7tUbwLUGOJg4So='
WHERE
key_id = '148f1c8fb8467c153d8353a3d78c4ff86bb88620e71c74eb0cf0ffd8c6c28a36'
AND (
token = 'hRMsJ5TynqHGl2xWyVcglvHY8FZuc7tUbwLUGOJg4So='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)