UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UZGh8v643G8Q7bVdRgpgwULNleJlyzl7QHnK8wKRBEk='
WHERE
key_id = 'c852830ca7e807f849d38c6ae6b1fc73ea2cf669e04a7e0c1591f1b2f96bc0f4'
AND (
token = 'UZGh8v643G8Q7bVdRgpgwULNleJlyzl7QHnK8wKRBEk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)