UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6WW+7Igpv9/eAWcOhzDae9J769FUuOYwjDIV6UBZ+gk='
WHERE
key_id = '79e88dafaf0cbdbe8b30c5eb43e0474f1198794b4d4663a2dc9b8a882aca9b03'
AND (
token = '6WW+7Igpv9/eAWcOhzDae9J769FUuOYwjDIV6UBZ+gk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)