UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VnXy5CKjLLES5ezwiF+ESNMmwK1YPkJ3wVLe+5xZF/w='
WHERE
key_id = '9b87f85d8a27711ef2e361bbbd752c73619a7307a85f6b0f88d64fd3f747d7c6'
AND (
token = 'VnXy5CKjLLES5ezwiF+ESNMmwK1YPkJ3wVLe+5xZF/w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)