UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p9WBfOx6GfRWc6Auo2tx7GgPzmwuOG+384Yw80msJeQ='
WHERE
key_id = 'ae7c216daccee88b89a247f8600aee53702a398a68129bd131d551ad25883115'
AND (
token = 'p9WBfOx6GfRWc6Auo2tx7GgPzmwuOG+384Yw80msJeQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)