UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HA5hgA4Q3mD2il0BYLicHZktY/uavnvDoreMp7liIL0='
WHERE
key_id = '1fffbba2dc1dad2bc3e56c9be970a225098dae0f50677c2ebec8e69a85da4918'
AND (
token = 'HA5hgA4Q3mD2il0BYLicHZktY/uavnvDoreMp7liIL0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)