UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nFI0QEYdoiYUeHUmOKxsDBbiK4VNWrW1e5xd8jbtIDY='
WHERE
key_id = '5dd94c5eab3771474b3efd5a84f8af68f5265c79957b99f613b23732b362bc58'
AND (
token = 'nFI0QEYdoiYUeHUmOKxsDBbiK4VNWrW1e5xd8jbtIDY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)