UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+zLPKIMaq1XamJ8k2l10mFsBHPyBnj6t6OdRNVGHR5o='
WHERE
key_id = '6e2527d6bf0eb180829be028c95d31a506a379f3a35af8a2e27a55a5f2315867'
AND (
token = '+zLPKIMaq1XamJ8k2l10mFsBHPyBnj6t6OdRNVGHR5o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)