UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HTN7C2qC0sUEtOIcWK47mHphAAG5wq1aVOVV5cZYVow='
WHERE
key_id = '0ddf2647e43f5ff84f0f05cb02d88414b4d7799d8cfcc025795d8adb847a54ad'
AND (
token = 'HTN7C2qC0sUEtOIcWK47mHphAAG5wq1aVOVV5cZYVow='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)