UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6iYrNs6Rf6lSvV4tt258D38yhjAfOSzrybtrCEkghlU='
WHERE
key_id = 'eaae6c75e07b9586e1efe9e71ee18ec1c59b84ac41487ab99bcde7c0c06400a8'
AND (
token = '6iYrNs6Rf6lSvV4tt258D38yhjAfOSzrybtrCEkghlU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)